Question: Why doesn't the Locks Held number in the Most Recent or Top Sample section agree with the total of the values shown in the Connections section?
Answer:
The Locks Held at the database level often disagrees with the total of the Locks Held at the connection level.
The values are captured at slightly different moments in time, and locks are often obtained and released
at a very high rate.
|